<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="gx143896">pg_namespace</title>
  <body>
    <p>The <codeph>pg_namespace</codeph> system catalog table stores namespaces.
A namespace is the structure underlying SQL schemas: each namespace can
have a separate collection of relations, types, etc. without name conflicts.</p>
    <table id="gx143898">
      <title>pg_catalog.pg_namespace</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry>
          </row></thead>
        <tbody>
          <row>
            <entry colname="col1"><codeph>oid</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3"/>
            <entry colname="col4">Row identifier (hidden attribute; must be explicitly selected)</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>nspname</codeph></entry>
            <entry colname="col2">name</entry>
            <entry colname="col3"/>
            <entry colname="col4">Name of the namespace</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>nspowner</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_authid.oid</entry>
            <entry colname="col4">Owner of the namespace</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>nspacl </codeph></entry>
            <entry colname="col2">aclitem[]</entry>
            <entry colname="col3"/>
            <entry colname="col4">Access privileges as given by <codeph>GRANT</codeph>
and <codeph>REVOKE</codeph></entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
